sdss.raw.analysis

Dataset statistics

Number of variables	11
Number of observations	2771159
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	38
Duplicate rows (%)	< 0.1%
Total size in memory	232.6 MiB
Average record size in memory	88.0 B

Variable types

Numeric	11

Alerts

Dataset has 38 (< 0.1%) duplicate rows	Duplicates
`u` is highly correlated with `g` and 8 other fields	High correlation
`g` is highly correlated with `u` and 8 other fields	High correlation
`r` is highly correlated with `u` and 8 other fields	High correlation
`i` is highly correlated with `u` and 8 other fields	High correlation
`z` is highly correlated with `u` and 8 other fields	High correlation
`uErr` is highly correlated with `u` and 8 other fields	High correlation
`gErr` is highly correlated with `u` and 8 other fields	High correlation
`rErr` is highly correlated with `u` and 8 other fields	High correlation
`iErr` is highly correlated with `u` and 8 other fields	High correlation
`zErr` is highly correlated with `u` and 8 other fields	High correlation
`u` is highly correlated with `g` and 2 other fields	High correlation
`g` is highly correlated with `u` and 4 other fields	High correlation
`r` is highly correlated with `rErr`	High correlation
`i` is highly correlated with `iErr`	High correlation
`z` is highly correlated with `g` and 2 other fields	High correlation
`uErr` is highly correlated with `u` and 2 other fields	High correlation
`gErr` is highly correlated with `u` and 4 other fields	High correlation
`rErr` is highly correlated with `r`	High correlation
`iErr` is highly correlated with `i`	High correlation
`zErr` is highly correlated with `g` and 2 other fields	High correlation
`u` is highly correlated with `g` and 4 other fields	High correlation
`g` is highly correlated with `u` and 8 other fields	High correlation
`r` is highly correlated with `u` and 7 other fields	High correlation
`i` is highly correlated with `g` and 6 other fields	High correlation
`z` is highly correlated with `g` and 6 other fields	High correlation
`uErr` is highly correlated with `u` and 2 other fields	High correlation
`gErr` is highly correlated with `u` and 8 other fields	High correlation
`rErr` is highly correlated with `u` and 7 other fields	High correlation
`iErr` is highly correlated with `g` and 6 other fields	High correlation
`zErr` is highly correlated with `g` and 6 other fields	High correlation
`u` is highly skewed (γ1 = -398.6854988)	Skewed
`g` is highly skewed (γ1 = -424.5365597)	Skewed
`i` is highly skewed (γ1 = -666.5307062)	Skewed
`z` is highly skewed (γ1 = -476.0855038)	Skewed
`uErr` is highly skewed (γ1 = -403.3646815)	Skewed
`gErr` is highly skewed (γ1 = -429.7716532)	Skewed
`iErr` is highly skewed (γ1 = -679.5562007)	Skewed
`zErr` is highly skewed (γ1 = -480.4752825)	Skewed

Reproduction

Analysis started	2022-02-27 19:50:53.897983
Analysis finished	2022-02-27 19:54:24.488465
Duration	3 minutes and 30.59 seconds
Software version	pandas-profiling v3.1.1
Download configuration	config.json

ID
Real number (ℝ_≥0)

Distinct	2771121
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.237664767 × 10¹⁸

Minimum	1.23764588 × 10¹⁸
Maximum	1.237680531 × 10¹⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.1 MiB

Quantile statistics

Minimum	1.23764588 × 10¹⁸
5-th percentile	1.237651538 × 10¹⁸
Q1	1.237658613 × 10¹⁸
median	1.237663784 × 10¹⁸
Q3	1.237668298 × 10¹⁸
95-th percentile	1.237679541 × 10¹⁸
Maximum	1.237680531 × 10¹⁸
Range	3.465180558 × 10¹³
Interquartile range (IQR)	9.685164556 × 10¹²

Descriptive statistics

Standard deviation	8.395171953 × 10¹²
Coefficient of variation (CV)	6.783074202 × 10^-6
Kurtosis	-0.5908909818
Mean	1.237664767 × 10¹⁸
Median Absolute Deviation (MAD)	4.663256416 × 10¹²
Skewness	0.3696698272
Sum	-3.735202359 × 10¹⁷
Variance	7.047891212 × 10²⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.237657072 × 10¹⁸	2	< 0.1%
1.237658612 × 10¹⁸	2	< 0.1%
1.23765707 × 10¹⁸	2	< 0.1%
1.237663239 × 10¹⁸	2	< 0.1%
1.237671765 × 10¹⁸	2	< 0.1%
1.237678663 × 10¹⁸	2	< 0.1%
1.237663783 × 10¹⁸	2	< 0.1%
1.23766533 × 10¹⁸	2	< 0.1%
1.237657858 × 10¹⁸	2	< 0.1%
1.237663783 × 10¹⁸	2	< 0.1%
Other values (2771111)	2771139	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.23764588 × 10¹⁸	1	< 0.1%
1.23764588 × 10¹⁸	1	< 0.1%
1.23764588 × 10¹⁸	1	< 0.1%
1.23764588 × 10¹⁸	1	< 0.1%
1.23764588 × 10¹⁸	1	< 0.1%
1.23764588 × 10¹⁸	1	< 0.1%
1.23764588 × 10¹⁸	1	< 0.1%
1.23764588 × 10¹⁸	1	< 0.1%
1.23764588 × 10¹⁸	1	< 0.1%
1.23764588 × 10¹⁸	1	< 0.1%

Value	Count	Frequency (%)
1.237680531 × 10¹⁸	1	< 0.1%
1.237680531 × 10¹⁸	1	< 0.1%
1.237680531 × 10¹⁸	1	< 0.1%
1.237680531 × 10¹⁸	1	< 0.1%
1.237680531 × 10¹⁸	1	< 0.1%
1.237680531 × 10¹⁸	1	< 0.1%
1.237680531 × 10¹⁸	1	< 0.1%
1.237680531 × 10¹⁸	1	< 0.1%
1.237680531 × 10¹⁸	1	< 0.1%
1.237680531 × 10¹⁸	1	< 0.1%

u
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	862299
Distinct (%)	31.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.48569117

Minimum	-9999
Maximum	33.45042
Zeros	0
Zeros (%)	0.0%
Negative	17
Negative (%)	< 0.1%
Memory size	21.1 MiB

Quantile statistics

Minimum	-9999
5-th percentile	18.743918
Q1	20.68278
median	22.81066
Q3	24.18339
95-th percentile	26.06422
Maximum	33.45042
Range	10032.45042
Interquartile range (IQR)	3.50061

Descriptive statistics

Standard deviation	24.92592762
Coefficient of variation (CV)	1.108523969
Kurtosis	160288.9449
Mean	22.48569117
Median Absolute Deviation (MAD)	1.62966
Skewness	-398.6854988
Sum	62311425.46
Variance	621.3018678
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24.63466	363	< 0.1%
24.63467	315	< 0.1%
24.63465	259	< 0.1%
24.63468	224	< 0.1%
24.63469	101	< 0.1%
24.6347	73	< 0.1%
24.63464	71	< 0.1%
24.63471	32	< 0.1%
24.63463	24	< 0.1%
24.63472	22	< 0.1%
Other values (862289)	2769675	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-9999	17	< 0.1%
7.918076	1	< 0.1%
9.866534	1	< 0.1%
9.941942	1	< 0.1%
10.17025	1	< 0.1%
10.22717	1	< 0.1%
10.48895	1	< 0.1%
10.54181	1	< 0.1%
11.0643	1	< 0.1%
11.21397	1	< 0.1%

Value	Count	Frequency (%)
33.45042	1	< 0.1%
32.66663	1	< 0.1%
31.77132	1	< 0.1%
31.38664	1	< 0.1%
31.10792	1	< 0.1%
30.96	1	< 0.1%
30.81344	1	< 0.1%
30.77991	1	< 0.1%
30.77358	1	< 0.1%
30.76049	1	< 0.1%

g
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	771110
Distinct (%)	27.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20.80203725

Minimum	-9999
Maximum	33.72469
Zeros	0
Zeros (%)	0.0%
Negative	15
Negative (%)	< 0.1%
Memory size	21.1 MiB

Quantile statistics

Minimum	-9999
5-th percentile	17.24236
Q1	18.79789
median	21.54917
Q3	22.42595
95-th percentile	23.56188
Maximum	33.72469
Range	10032.72469
Interquartile range (IQR)	3.62806

Descriptive statistics

Standard deviation	23.40800036
Coefficient of variation (CV)	1.125274418
Kurtosis	181720.1326
Mean	20.80203725
Median Absolute Deviation (MAD)	1.22679
Skewness	-424.5365597
Sum	57645752.73
Variance	547.9344807
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
25.11438	108	< 0.1%
25.11437	66	< 0.1%
25.11439	57	< 0.1%
25.1144	45	< 0.1%
22.2569	25	< 0.1%
22.14977	25	< 0.1%
22.03572	24	< 0.1%
22.23071	23	< 0.1%
22.19956	23	< 0.1%
22.11493	23	< 0.1%
Other values (771100)	2770740	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-9999	15	< 0.1%
7.466997	1	< 0.1%
9.897096	1	< 0.1%
10.24659	1	< 0.1%
10.32773	1	< 0.1%
10.40744	1	< 0.1%
10.53339	1	< 0.1%
10.64063	1	< 0.1%
10.75463	1	< 0.1%
11.10078	1	< 0.1%

Value	Count	Frequency (%)
33.72469	1	< 0.1%
32.90944	1	< 0.1%
32.14997	1	< 0.1%
31.67036	1	< 0.1%
31.60224	1	< 0.1%
31.52315	1	< 0.1%
31.35417	1	< 0.1%
31.32736	1	< 0.1%
31.06618	1	< 0.1%
30.95307	1	< 0.1%

r
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	701820
Distinct (%)	25.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19.52903535

Minimum	8.902843
Maximum	22.99995
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.1 MiB

Quantile statistics

Minimum	8.902843
5-th percentile	16.4361
Q1	17.74938
median	20.05903
Q3	20.9397
95-th percentile	22.10703
Maximum	22.99995
Range	14.097107
Interquartile range (IQR)	3.19032

Descriptive statistics

Standard deviation	1.868180367
Coefficient of variation (CV)	0.09566168188
Kurtosis	-0.7443412122
Mean	19.52903535
Median Absolute Deviation (MAD)	1.34907
Skewness	-0.4281030079
Sum	54118062.08
Variance	3.490097884
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20.5507	23	< 0.1%
20.29045	22	< 0.1%
20.52563	22	< 0.1%
20.50425	22	< 0.1%
20.63658	22	< 0.1%
20.78461	22	< 0.1%
20.44975	22	< 0.1%
20.43664	22	< 0.1%
20.61646	22	< 0.1%
20.71745	22	< 0.1%
Other values (701810)	2770938	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8.902843	1	< 0.1%
9.474476	1	< 0.1%
9.501574	1	< 0.1%
9.848258	1	< 0.1%
9.903746	1	< 0.1%
9.920951	1	< 0.1%
10.04462	1	< 0.1%
10.07247	1	< 0.1%
10.10956	1	< 0.1%
10.13125	1	< 0.1%

Value	Count	Frequency (%)
22.99995	1	< 0.1%
22.99994	1	< 0.1%
22.99993	2	< 0.1%
22.99991	1	< 0.1%
22.9999	1	< 0.1%
22.99981	2	< 0.1%
22.9998	1	< 0.1%
22.99973	1	< 0.1%
22.99971	1	< 0.1%
22.99968	1	< 0.1%

i
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	684993
Distinct (%)	24.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.77579059

Minimum	-9999
Maximum	31.65274
Zeros	0
Zeros (%)	0.0%
Negative	6
Negative (%)	< 0.1%
Memory size	21.1 MiB

Quantile statistics

Minimum	-9999
5-th percentile	16.02066
Q1	17.31647
median	19.17877
Q3	19.91381
95-th percentile	21.405591
Maximum	31.65274
Range	10030.65274
Interquartile range (IQR)	2.59734

Descriptive statistics

Standard deviation	14.83638504
Coefficient of variation (CV)	0.7901869685
Kurtosis	450050.0913
Mean	18.77579059
Median Absolute Deviation (MAD)	1.14519
Skewness	-666.5307062
Sum	52030701.06
Variance	220.1183212
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24.3618	78	< 0.1%
24.36181	47	< 0.1%
19.74928	27	< 0.1%
19.523	26	< 0.1%
19.61283	26	< 0.1%
19.66745	26	< 0.1%
19.56573	25	< 0.1%
19.54819	25	< 0.1%
19.6445	25	< 0.1%
19.69037	25	< 0.1%
Other values (684983)	2770829	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-9999	6	< 0.1%
8.364965	1	< 0.1%
8.411285	1	< 0.1%
9.370869	1	< 0.1%
9.527082	1	< 0.1%
9.550007	1	< 0.1%
9.568777	1	< 0.1%
9.75404	1	< 0.1%
9.85052	1	< 0.1%
9.886005	1	< 0.1%

Value	Count	Frequency (%)
31.65274	1	< 0.1%
31.23163	1	< 0.1%
31.14982	1	< 0.1%
31.07335	1	< 0.1%
30.84629	1	< 0.1%
30.83151	1	< 0.1%
30.71105	1	< 0.1%
30.65209	1	< 0.1%
30.57623	1	< 0.1%
30.49861	1	< 0.1%

z
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	683964
Distinct (%)	24.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.35172229

Minimum	-9999
Maximum	30.01704
Zeros	0
Zeros (%)	0.0%
Negative	12
Negative (%)	< 0.1%
Memory size	21.1 MiB

Quantile statistics

Minimum	-9999
5-th percentile	15.702359
Q1	17.02602
median	18.72145
Q3	19.44232
95-th percentile	21.12194
Maximum	30.01704
Range	10029.01704
Interquartile range (IQR)	2.4163

Descriptive statistics

Standard deviation	20.91051379
Coefficient of variation (CV)	1.139430592
Kurtosis	228069.9466
Mean	18.35172229
Median Absolute Deviation (MAD)	1.01414
Skewness	-476.0855038
Sum	50855540.38
Variance	437.2495869
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
22.8269	569	< 0.1%
22.82691	330	< 0.1%
22.82689	170	< 0.1%
22.82692	89	< 0.1%
22.82693	41	< 0.1%
22.82694	31	< 0.1%
19.17929	29	< 0.1%
19.25344	28	< 0.1%
19.21716	28	< 0.1%
19.15662	27	< 0.1%
Other values (683954)	2769817	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-9999	12	< 0.1%
6.485586	1	< 0.1%
6.972855	1	< 0.1%
7.140388	1	< 0.1%
7.281719	1	< 0.1%
9.563122	1	< 0.1%
9.673311	1	< 0.1%
9.759146	1	< 0.1%
9.771158	1	< 0.1%
9.971849	1	< 0.1%

Value	Count	Frequency (%)
30.01704	1	< 0.1%
29.38374	1	< 0.1%
29.26314	1	< 0.1%
29.18374	1	< 0.1%
29.17408	1	< 0.1%
29.04169	1	< 0.1%
29.03935	1	< 0.1%
29.0194	1	< 0.1%
28.96626	1	< 0.1%
28.91793	1	< 0.1%

uErr
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	2426286
Distinct (%)	87.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.6182142492

Minimum	-9999
Maximum	68.59662
Zeros	0
Zeros (%)	0.0%
Negative	17
Negative (%)	< 0.1%
Memory size	21.1 MiB

Quantile statistics

Minimum	-9999
5-th percentile	0.034035557
Q1	0.1267441
median	0.5586334
Q3	1.039912
95-th percentile	1.7884133
Maximum	68.59662
Range	10067.59662
Interquartile range (IQR)	0.9131679

Descriptive statistics

Standard deviation	24.77498648
Coefficient of variation (CV)	40.07508161
Kurtosis	162802.3021
Mean	0.6182142492
Median Absolute Deviation (MAD)	0.447231
Skewness	-403.3646815
Sum	1713169.98
Variance	613.7999553
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-9999	17	< 0.1%
1.20849	8	< 0.1%
1.136649	8	< 0.1%
1.069763	8	< 0.1%
1.018593	8	< 0.1%
1.040624	8	< 0.1%
1.151895	8	< 0.1%
1.176417	8	< 0.1%
1.160801	7	< 0.1%
1.240877	7	< 0.1%
Other values (2426276)	2771072	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-9999	17	< 0.1%
0.0001527219	1	< 0.1%
0.0002531087	1	< 0.1%
0.0005957853	1	< 0.1%
0.0006323291	1	< 0.1%
0.001352592	1	< 0.1%
0.001526264	1	< 0.1%
0.002129648	1	< 0.1%
0.002286536	1	< 0.1%
0.002411008	1	< 0.1%

Value	Count	Frequency (%)
68.59662	1	< 0.1%
55.50948	1	< 0.1%
46.49884	1	< 0.1%
40.79873	1	< 0.1%
39.44621	1	< 0.1%
38.20195	1	< 0.1%
36.87848	1	< 0.1%
30.9955	1	< 0.1%
28.22746	1	< 0.1%
27.37109	1	< 0.1%

gErr
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	2400043
Distinct (%)	86.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.08109698909

Minimum	-9999
Maximum	41.14543
Zeros	0
Zeros (%)	0.0%
Negative	15
Negative (%)	< 0.1%
Memory size	21.1 MiB

Quantile statistics

Minimum	-9999
5-th percentile	0.0055363294
Q1	0.013174905
median	0.09019347
Q3	0.17298095
95-th percentile	0.4513975
Maximum	41.14543
Range	10040.14543
Interquartile range (IQR)	0.159806045

Descriptive statistics

Standard deviation	23.26435021
Coefficient of variation (CV)	286.8707023
Kurtosis	184714.2977
Mean	0.08109698909
Median Absolute Deviation (MAD)	0.07794734
Skewness	-429.7716532
Sum	224732.6512
Variance	541.2299908
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-9999	15	< 0.1%
0.10794	7	< 0.1%
0.128186	7	< 0.1%
0.1490033	7	< 0.1%
0.1224872	7	< 0.1%
0.14268	7	< 0.1%
0.1148187	7	< 0.1%
0.115449	7	< 0.1%
0.1088042	7	< 0.1%
0.1223937	7	< 0.1%
Other values (2400033)	2771081	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-9999	15	< 0.1%
0.0002041792	1	< 0.1%
0.000344248	1	< 0.1%
0.0003744256	1	< 0.1%
0.0004111342	1	< 0.1%
0.0004521218	1	< 0.1%
0.0005116757	1	< 0.1%
0.0005221947	1	< 0.1%
0.0005407966	1	< 0.1%
0.000569647	1	< 0.1%

Value	Count	Frequency (%)
41.14543	1	< 0.1%
40.80777	1	< 0.1%
27.87659	1	< 0.1%
25.20317	1	< 0.1%
18.66603	1	< 0.1%
16.81018	1	< 0.1%
14.3314	1	< 0.1%
13.89603	1	< 0.1%
13.56933	1	< 0.1%
12.59677	1	< 0.1%

rErr
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2512735
Distinct (%)	90.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.05601125719

Minimum	0.0002880982
Maximum	14.52429
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.1 MiB

Quantile statistics

Minimum	0.0002880982
5-th percentile	0.004357583
Q1	0.008711278
median	0.03777241
Q3	0.073950285
95-th percentile	0.18078481
Maximum	14.52429
Range	14.5240019
Interquartile range (IQR)	0.065239007

Descriptive statistics

Standard deviation	0.06815645868
Coefficient of variation (CV)	1.21683501
Kurtosis	1299.621293
Mean	0.05601125719
Median Absolute Deviation (MAD)	0.029996825
Skewness	11.73242203
Sum	155216.0995
Variance	0.00464530286
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.1017352	6	< 0.1%
0.1579721	6	< 0.1%
0.1084829	6	< 0.1%
0.1031431	6	< 0.1%
0.1278086	6	< 0.1%
0.1030422	6	< 0.1%
0.1009113	6	< 0.1%
0.1029735	6	< 0.1%
0.1349871	6	< 0.1%
0.04695546	6	< 0.1%
Other values (2512725)	2771099	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0002880982	1	< 0.1%
0.0002945296	1	< 0.1%
0.0003206228	1	< 0.1%
0.0003519821	1	< 0.1%
0.0003707175	1	< 0.1%
0.0003707407	1	< 0.1%
0.0003747093	1	< 0.1%
0.0003870378	1	< 0.1%
0.0004120384	1	< 0.1%
0.0004849193	1	< 0.1%

Value	Count	Frequency (%)
14.52429	1	< 0.1%
9.04069	1	< 0.1%
8.556941	1	< 0.1%
8.420018	1	< 0.1%
7.712391	1	< 0.1%
7.497026	1	< 0.1%
7.276915	1	< 0.1%
5.528741	1	< 0.1%
5.501844	1	< 0.1%
5.124316	1	< 0.1%

iErr
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	2458989
Distinct (%)	88.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.0190022825

Minimum	-9999
Maximum	55.15096
Zeros	0
Zeros (%)	0.0%
Negative	6
Negative (%)	< 0.1%
Memory size	21.1 MiB

Quantile statistics

Minimum	-9999
5-th percentile	0.0043685914
Q1	0.008751204
median	0.02717291
Q3	0.04588176
95-th percentile	0.1377873
Maximum	55.15096
Range	10054.15096
Interquartile range (IQR)	0.037130556

Descriptive statistics

Standard deviation	14.71337641
Coefficient of variation (CV)	774.2952151
Kurtosis	461815.2536
Mean	0.0190022825
Median Absolute Deviation (MAD)	0.018490926
Skewness	-679.5562007
Sum	52658.34617
Variance	216.4834455
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0293873	7	< 0.1%
0.02603347	6	< 0.1%
0.01029926	6	< 0.1%
0.03017065	6	< 0.1%
0.02851547	6	< 0.1%
0.01049611	6	< 0.1%
-9999	6	< 0.1%
0.0119009	6	< 0.1%
0.01132452	6	< 0.1%
0.03408777	6	< 0.1%
Other values (2458979)	2771098	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-9999	6	< 0.1%
4.2032 × 10^-6	1	< 0.1%
0.0002416363	1	< 0.1%
0.0002654212	1	< 0.1%
0.0002655984	1	< 0.1%
0.0003338849	1	< 0.1%
0.0003575227	1	< 0.1%
0.0003629721	1	< 0.1%
0.0004060516	1	< 0.1%
0.0004348774	1	< 0.1%

Value	Count	Frequency (%)
55.15096	1	< 0.1%
52.3215	1	< 0.1%
48.50616	1	< 0.1%
28.0332	1	< 0.1%
26.41502	1	< 0.1%
20.70949	1	< 0.1%
19.05205	1	< 0.1%
16.70047	1	< 0.1%
16.66532	1	< 0.1%
14.79383	1	< 0.1%

zErr
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	2398609
Distinct (%)	86.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.06009573046

Minimum	-9999
Maximum	125.6025
Zeros	0
Zeros (%)	0.0%
Negative	12
Negative (%)	< 0.1%
Memory size	21.1 MiB

Quantile statistics

Minimum	-9999
5-th percentile	0.0093093303
Q1	0.022616205
median	0.06647062
Q3	0.11302155
95-th percentile	0.36526517
Maximum	125.6025
Range	10124.6025
Interquartile range (IQR)	0.090405345

Descriptive statistics

Standard deviation	20.80856889
Coefficient of variation (CV)	346.2570257
Kurtosis	230878.3021
Mean	0.06009573046
Median Absolute Deviation (MAD)	0.04462266
Skewness	-480.4752825
Sum	166534.8243
Variance	432.9965392
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-9999	12	< 0.1%
0.1069008	9	< 0.1%
0.1196612	8	< 0.1%
0.10416	8	< 0.1%
0.104101	8	< 0.1%
0.1038319	8	< 0.1%
0.1070111	8	< 0.1%
0.1069292	8	< 0.1%
0.101817	8	< 0.1%
0.1187577	8	< 0.1%
Other values (2398599)	2771074	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-9999	12	< 0.1%
0.0001718631	1	< 0.1%
0.00020425	1	< 0.1%
0.0002246803	1	< 0.1%
0.0004583807	1	< 0.1%
0.0004735135	1	< 0.1%
0.0009759665	1	< 0.1%
0.001006559	1	< 0.1%
0.001018574	1	< 0.1%
0.001079047	1	< 0.1%

Value	Count	Frequency (%)
125.6025	1	< 0.1%
70.74406	1	< 0.1%
51.20518	1	< 0.1%
48.38092	1	< 0.1%
43.06553	1	< 0.1%
38.72721	1	< 0.1%
35.62029	1	< 0.1%
33.70526	1	< 0.1%
28.62317	1	< 0.1%
28.58433	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	ID	u	g	r	i	z	uErr	gErr	rErr	iErr	zErr
0	1237671129125683920	24.70152	22.30560	21.74474	21.40080	21.42348	0.781686	0.098980	0.078220	0.082370	0.240668
1	1237657772314394978	22.67397	21.96686	21.94899	21.72379	21.86105	0.390818	0.077608	0.128782	0.172128	0.565489
2	1237660764832400503	26.18586	22.41516	21.65361	21.57355	21.89604	0.371185	0.111313	0.079666	0.103673	0.496207
3	1237665584334570546	24.60471	21.87256	21.65432	21.64291	22.18519	0.826998	0.060778	0.065266	0.100126	0.507707
4	1237657190904300059	25.12164	22.79996	22.21146	21.85425	22.10207	0.682036	0.133950	0.111180	0.112090	0.480457
5	1237663543144874769	24.09210	22.85346	22.30763	22.04790	22.40283	0.642321	0.129014	0.124250	0.135843	0.529423
6	1237680503433463381	23.98054	24.24618	22.73013	21.30288	19.85708	1.701148	0.932739	0.479780	0.194279	0.188464
7	1237668298210279496	24.17533	26.84352	20.13889	18.72636	21.07554	2.558426	0.675604	0.061569	0.060317	0.877250
8	1237657877000749920	21.80250	20.75988	20.21546	20.13754	20.19818	0.138595	0.031938	0.025508	0.032024	0.116473
9	1237668350284333541	25.30149	21.97474	21.25391	21.16108	21.16152	0.645250	0.078875	0.052745	0.067674	0.213721

Last rows

	ID	u	g	r	i	z	uErr	gErr	rErr	iErr	zErr
2771149	1237680100240786188	23.05869	22.36168	21.53303	21.11670	20.31947	0.601664	0.136826	0.119876	0.113521	0.223924
2771150	1237662302978114005	21.71403	21.37239	20.93563	20.71536	20.44528	0.125691	0.041273	0.040624	0.046867	0.112831
2771151	1237658611977028500	24.82571	23.13886	21.54026	20.30895	19.37826	2.869478	0.584235	0.202527	0.099133	0.153437
2771152	1237665584327098663	19.93252	19.61594	19.43063	19.45920	19.33438	0.039515	0.013005	0.013562	0.019402	0.055167
2771153	1237678790817284224	20.07754	19.66287	19.60898	19.63647	20.09604	0.055920	0.014554	0.019643	0.027199	0.162892
2771154	1237669701051154669	21.69291	21.80268	21.37547	21.36539	21.50789	0.205582	0.091514	0.109365	0.164178	0.592550
2771155	1237651535483830513	21.12952	21.31596	21.49134	21.18736	20.98013	0.102443	0.056157	0.089118	0.101749	0.310130
2771156	1237680311229809450	22.07685	21.79657	21.48659	21.40146	20.84215	0.232213	0.056864	0.076320	0.100319	0.263959
2771157	1237661463836229952	21.26601	20.75931	20.57111	20.42262	20.52666	0.085725	0.024749	0.028326	0.033730	0.121159
2771158	1237649920043581852	22.59109	21.27139	20.82199	20.61607	20.61585	0.305951	0.048192	0.045708	0.055666	0.222432

Most frequently occurring

	ID	u	g	r	i	z	uErr	gErr	rErr	iErr	zErr	# duplicates
0	1237649920046661771	18.92138	17.15256	16.11338	15.58986	15.17178	0.053663	0.006482	0.004357	0.004112	0.009762	2
1	1237653664718127323	20.03431	17.97154	16.85417	16.39723	15.94599	0.067821	0.007178	0.004625	0.004675	0.010448	2
2	1237655106771812489	19.90797	18.02617	17.01220	16.60744	16.26283	0.054020	0.007359	0.004823	0.004689	0.009639	2
3	1237655369831481388	18.87476	16.73923	15.59903	14.99624	14.48176	0.053057	0.004954	0.003337	0.003123	0.006469	2
4	1237655373577847178	17.28472	16.31550	15.81495	15.52917	15.28723	0.011611	0.003495	0.003124	0.003324	0.007057	2
5	1237657070088618230	23.04010	21.71487	21.54097	22.23682	22.60238	0.579544	0.078190	0.098634	0.260900	0.815591	2
6	1237657071698116685	18.36346	17.02286	16.59428	16.39064	16.24101	0.071954	0.012728	0.017125	0.021492	0.049975	2
7	1237657587096224096	19.95916	18.91797	18.44332	18.24111	18.08843	0.075555	0.017154	0.015753	0.029133	0.056606	2
8	1237657591393157322	17.85245	16.41396	15.85318	15.41643	15.11933	0.018482	0.003851	0.003545	0.004167	0.006736	2
9	1237657857680081097	19.12627	17.83440	17.08346	16.60760	16.30409	0.032253	0.006289	0.005009	0.005182	0.011097	2

Overview

Variables

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows

Duplicate rows

Most frequently occurring